﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Citi.PTSConsolidation.Domain
{
    public class ProjectProgramTemp
    {
        #region Mappings

        public static readonly Dictionary<string, string> ExcelColumnMappings = new Dictionary<string, string> { 
                { "[Project Id]", "[ProjectId]" },
                { "[Project Name]", "[ProjectName]" } ,
                { "[Program Id]", "[ProgramId]" },
                { "[Program Name]", "[ProgramName]" },
                { "[Program Investment Alignment Category]", "[ProgramInvestmentAlignmentCategory]" },
                { "[Key Business Contact]", "[KeyBusinessContact]" },
                { "[Technology Program Manager]", "[TechnologyProgramManager]" },
                { "[Tech Program Manager SMT]", "[TechProgramManagerSMT]" },
                { "[Tech Program Manager STLT]", "[TechProgramManagerSTLT]" }
            };

        #endregion

        public static string GetQueryDelete()
        {
            return "DELETE FROM ProjectProgramTemp";
        }

        public static string GetQueryMergeProjects()
        {
            return "EXEC sp_MergeProject";
        }

        public static string GetQueryProgramWithoutOwner()
        {
            return "SELECT * FROM Program WHERE ProgramOwner IS NULL";
        }

        public static string GetQueryMergePrograms()
        {
            return "EXEC sp_MergeProgram";
        }

        public static string QueryExcel = 
                @"SELECT DISTINCT
                        [Project Id],	
                        [Project Name],	
                        [Program Id],	
                        [Program Name],	
                        [Program Investment Alignment Category],	
                        [Key Business Contact],	
                        [Technology Program Manager],	
                        [Tech Program Manager SMT],	
                        [Tech Program Manager STLT]
                FROM [{0}]
                WHERE [Project Id] IS NOT NULL";
    }
}
